USE [SpringSocial]
GO

/****** Object:  Table [dbo].[Country]    Script Date: 03/22/2012 18:17:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Country](
	[code] [varchar](3) NOT NULL,
	[name] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED 
(
	[code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

INSERT INTO [dbo].[Country]([name],[code])VALUES('AFGHANISTAN','AFG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ALBANIA','ALB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ALGERIA','ALG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('AMERICAN SAMOA','ASA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ANDORRA','AND');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ANGOLA','ANG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ANGUILLA','AIA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ANTIGUA AND BARBUDA','ATG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ARGENTINA','ARG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ARMENIA','ARM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ARUBA','ARU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('AUSTRALIA','AUS');

INSERT INTO [dbo].[Country]([name],[code])VALUES('AUSTRIA','AUT');

INSERT INTO [dbo].[Country]([name],[code])VALUES('AZERBAIJAN','AZE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BAHAMAS','BAH');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BAHRAIN','BHR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BANGLADESH','BAN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BARBADOS','BRB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BELARUS','BLR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BELGIUM','BEL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BELIZE','BLZ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BENIN','BEN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BERMUDA','BER');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BHUTAN','BHU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BOLIVIA','BOL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BOSNIA AND HERZEGOVINA','BIH');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BOTSWANA','BOT');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BRAZIL','BRA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BRITISH VIRGIN ISLANDS','VGB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BRUNEI','BRU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BULGARIA','BUL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BURKINA FASO','BFA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('BURUNDI','BDI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CAMBODIA','CAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CAMEROON','CMR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CANADA','CAN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CAPE VERDE','CPV');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CAYMAN ISLANDS','CAY');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CENTRAL AFRICAN REPUBLIC','CTA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CHAD','CHA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CHILE','CHI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CHINA PR','CHN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CHINESE TAIPEI','TPE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('COLOMBIA','COL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('COMOROS','COM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CONGO','CGO');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CONGO DR','COD');

INSERT INTO [dbo].[Country]([name],[code])VALUES('COOK ISLANDS','COK');

INSERT INTO [dbo].[Country]([name],[code])VALUES('COSTA RICA','CRC');

INSERT INTO [dbo].[Country]([name],[code])VALUES('Cote dIvoire','CIV');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CROATIA','CRO');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CUBA','CUB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CURACAO','CUW');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CYPRUS','CYP');

INSERT INTO [dbo].[Country]([name],[code])VALUES('CZECH REPUBLIC','CZE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('DENMARK','DEN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('DJIBOUTI','DJI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('DOMINICA','DMA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('DOMINICAN REPUBLIC','DOM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ECUADOR','ECU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('EGYPT','EGY');

INSERT INTO [dbo].[Country]([name],[code])VALUES('EL SALVADOR','SLV');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ENGLAND','ENG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('EQUATORIAL GUINEA','EDG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ERITREA','ERI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ESTONIA','EST');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ETHIOPIA','ETH');

INSERT INTO [dbo].[Country]([name],[code])VALUES('FAROE ISLANDS','FRO');

INSERT INTO [dbo].[Country]([name],[code])VALUES('FIJI','FIJ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('FINLAND','FIN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('FRANCE','FRA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GABON','GAB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GAMBIA','GAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GEORGIA','GEO');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GERMANY','GER');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GHANA','GHA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GREECE','GRE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GRENADA','GRN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GUAM','GUM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GUATEMALA','GUA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GUINEA','GUI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GUINEA-BISSAU','GNB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('GUYANA','GUY');

INSERT INTO [dbo].[Country]([name],[code])VALUES('HAITI','HAI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('HONDURAS','HON');

INSERT INTO [dbo].[Country]([name],[code])VALUES('HONG KONG','HKG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('HUNGARY','HUN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ICELAND','ISL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('INDIA','IND');

INSERT INTO [dbo].[Country]([name],[code])VALUES('INDONESIA','IDN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('IRAN','IRN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('IRAQ','IRQ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ISRAEL','ISR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ITALY','ITA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('JAMAICA','JAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('JAPAN','JPN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('JORDAN','JOR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('KAZAKHSTAN','KAZ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('KENYA','KEN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NORТH KOREA','PRK');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SOUTH KOREA','KOR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('KUWAIT','KUW');

INSERT INTO [dbo].[Country]([name],[code])VALUES('KYRGYZSTAN','KGZ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LAOS','LAO');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LATVIA','LVA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LEBANON','LIB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LESOTHO','LES');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LIBERIA','LBR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LIBYA','LBY');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LIECHTENSTEIN','LIE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LITHUANIA','LTU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('LUXEMBOURG','LUX');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MACAU','MAC');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MACEDONIA','MKD');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MADAGASCAR','MAD');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MALAWI','MWI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MALAYSIA','MAS');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MALDIVES','MDV');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MALI','MLI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MALTA','MLT');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MAURITANIA','MTN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MAURITIUS','MRI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MEXICO','MEX');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MOLDOVA','MDA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MONGOLIA','MGL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MONTENEGRO','MNE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MONTSERRAT','MSR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MOROCCO','MAR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MOZAMBIQUE','MOZ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('MYANMAR','MYA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NAMIBIA','NAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NEPAL','NEP');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NETHERLANDS','NED');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NEW CALEDONIA','NCL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NEW ZEALAND','NZL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NICARAGUA','NCA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NIGER','NIG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NIGERIA','NGA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NORTHERN IRELAND','NIR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('NORWAY','NOR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('OMAN','OMA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PAKISTAN','PAK');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PALESTINE','PLE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PANAMA','PAN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PAPUA NEW GUINEA','PNG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PARAGUAY','PAR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PERU','PER');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PHILIPPINES','PHI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('POLAND','POL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PORTUGAL','POR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('PUERTO RICO','PUR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('QATAR','QAT');

INSERT INTO [dbo].[Country]([name],[code])VALUES('REPUBLIC OF IRELAND','IRL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ROMANIA','ROU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('RUSSIA','RUS');

INSERT INTO [dbo].[Country]([name],[code])VALUES('RWANDA','RWA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAINT KITTS AND NEVIS','SKN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAINT LUCIA','LCA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAINT VINCENT AND THE GRENADINES','VIN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAMOA','SAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAN MARINO','SMR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAO TOME AND PRINCIPE','STP');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SAUDI ARABIA','KSA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SENEGAL','SEN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SERBIA','SRB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SEYCHELLES','SEY');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SIERRA LEONE','SLE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SINGAPORE','SIN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SLOVAKIA','SVK');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SLOVENIA','SVN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SOLOMON ISLANDS','SOL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SOMALIA','SOM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SOUTH AFRICA','RSA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SPAIN','ESP');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SRI LANKA','SRI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SUDAN','SDN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SURINAME','SUR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SWAZILAND','SWZ');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SWEDEN','SWE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SWITZERLAND','SUI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('SYRIA','SYR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TAHITI','TAH');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TAJIKISTAN','TJK');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TANZANIAF','TAN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('THAILAND','THA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TIMOR-LESTE','TLS');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TOGO','TOG');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TONGA','TGA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TRINIDAD AND TOBAGO','TRI');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TUNISIA','TUN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TURKEY','TUR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TURKMENISTAN','TKM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('TURKS AND CAICOS ISLANDS','TCA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('UGANDA','UGA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('UKRAINE','UKR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('UNITED ARAB EMIRATES','UAE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('UNITED STATES','USA');

INSERT INTO [dbo].[Country]([name],[code])VALUES('URUGUAY','URU');

INSERT INTO [dbo].[Country]([name],[code])VALUES('U.S. VIRGIN ISLANDS','VIR');

INSERT INTO [dbo].[Country]([name],[code])VALUES('UZBEKISTAN','UZB');

INSERT INTO [dbo].[Country]([name],[code])VALUES('VANUATU','VAN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('VENEZUELA','VEN');

INSERT INTO [dbo].[Country]([name],[code])VALUES('VIETNAM','VIE');

INSERT INTO [dbo].[Country]([name],[code])VALUES('WALES','WAL');

INSERT INTO [dbo].[Country]([name],[code])VALUES('YEMEN','YEM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ZAMBIA','ZAM');

INSERT INTO [dbo].[Country]([name],[code])VALUES('ZIMBABWE','ZIM');
